<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_company_rating`;");
CreateTable("CREATE TABLE `phpyun_company_rating` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `service_price` varchar(100) DEFAULT NULL,
  `integral_buy` varchar(100) DEFAULT NULL,
  `yh_price` varchar(100) DEFAULT NULL,
  `yh_integral` varchar(100) DEFAULT NULL,
  `time_start` int(11) DEFAULT NULL,
  `time_end` int(11) DEFAULT NULL,
  `resume` int(5) DEFAULT NULL,
  `job_num` int(11) DEFAULT NULL,
  `interview` int(11) DEFAULT NULL,
  `editjob_num` int(11) DEFAULT NULL,
  `breakjob_num` int(11) DEFAULT NULL,
  `sort` int(10) DEFAULT NULL,
  `display` int(1) DEFAULT NULL,
  `explains` varchar(255) DEFAULT NULL,
  `com_pic` varchar(100) DEFAULT NULL,
  `com_color` varchar(100) DEFAULT NULL,
  `type` int(2) DEFAULT NULL,
  `lt_resume` int(11) DEFAULT NULL,
  `lt_job_num` int(11) DEFAULT NULL,
  `lt_editjob_num` int(11) DEFAULT NULL,
  `lt_breakjob_num` int(11) DEFAULT NULL,
  `category` int(2) DEFAULT NULL,
  `msg_num` int(11) DEFAULT '0',
  `service_time` int(11) DEFAULT NULL,
  `coupon` int(11) DEFAULT '0',
  `part_num` int(11) DEFAULT '0',
  `editpart_num` int(11) DEFAULT '0',
  `breakpart_num` int(11) DEFAULT '0',
  `zph_num` int(11) DEFAULT '0',
  `service_discount` int(2) DEFAULT NULL,
  `jobrec` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_company_rating` values('3','免费会员','0','0','0','0','0','0','5','3','10','1','2','0','0','终生免费会员','','#000000','1','0','0','0','0','1','0','0','0','6','2','2','0','0','1');");
ExcuteSQL("insert into `phpyun_company_rating` values('4','铜牌会员','199','95','0','0','0','0','50','50','50','0','10','1','1','铜牌会员','/data/upload/compic/20170208/14873574872.PNG','0','1','0','0','0','0','1','0','30','0','10','10','30','0','70','1');");
ExcuteSQL("insert into `phpyun_company_rating` values('5','银牌会员','299','250','0','0','0','0','180','600','80','6','10','2','1','银牌会员','','FFBC21','1','0','5','0','0','1','0','30','0','0','0','0','0','95','1');");
ExcuteSQL("insert into `phpyun_company_rating` values('6','金牌会员','399','900','0','0','0','0','800','888','800','100','100','3','1','金牌会员','/data/upload/compic/20170208/14902352353.PNG','FF1C14','1','0','0','0','0','1','0','30','0','10','10','10','20','80','1');");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>